{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["přihlášení","Tabulky","pavouk","Pořadí chlapci","Pořadí dívky"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"přihlášení","index":0,"n_rows":15,"n_cols":16,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["# hráče","jméno","nasazený",null,"Přehled",null,null,null,null,null,null,null,null,null,null,"21:10:00"]
[{"$f":"ROW()-1","v":1},"Kurylová Nikole - Weigert Matyáš",true,null,{"$f":"IF(OR(F4=11,F4<=7),\"Pozor, pro \"&F4&\" přihlášených hráčů není určená logika rozdělení!\",\"\")","v":""}]
[2,"Toman  Bruno -  Řehoř Benjamin",true,null,{"$f":"IF(rg_počet_nasazených>rg_pocet_skupin,\"Pozor, počet nasazených je vyšší, než počet skupin. Není připravená logika.\",\"\")","v":""}]
[3,"Mrázek Richard - Zýka Andreas",true,null,"počet přihlášených:",{"$f":"COUNTA(tbl_seznam_hracu[jméno])","v":14}]
[4,"Jiráková Sofie -  Adamcová Veronika",false,null,"počet nasazených:",{"$f":"COUNTIFS(tbl_seznam_hracu[nasazený],TRUE)","v":3}]
[5,"Zikmund Adam - Michna Lisa",false,null,"počet skupin:",{"$f":"ROUNDDOWN(F4/4,0)","v":3}]
[6,"Motal David - Mikeš David",false,null,"počet 5-ti členných skupin:",{"$f":"MOD(F4,4)","v":2}]
[7,"Šebísková Tereza -  Fiedlerová Enola",false]
[8,"Hrubeš Martin - Mabouka Sofia",false]
[9,"Suchánková Nikola -  Blaščík Matyáš",false]
[10,"Svoboda Adéla - Burešová Karolína",false]
[11,"Hugová Kateřina - Ječmínek Ondřej",false]
[12,"Roček  Vilém -  Plecitý Vilém",false,null,"Tabulka se seznamem hráčů musí být seřazena tak, že na začátku seznamu jsou nasazení hráči."]
[{"$f":"ROW()-1","v":13},"Bervid William - Wollner Filip",false]
[14,"Pospíšilová Anna - Stejskalová Julie",false]

{"sheet":"Tabulky","index":1,"n_rows":69,"n_cols":9,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
[]
["Skupina A - kurt ",null,"Kurylová Nikole - Weigert Matyáš","Hugová Kateřina - Ječmínek Ondřej","Suchánková Nikola -  Blaščík Matyáš","Bervid William - Wollner Filip","Pořadí","Počet vítězství"]
["A1","Kurylová Nikole - Weigert Matyáš",null,"6-3","6-4","6-3","1.","3"]
["A2","Hugová Kateřina - Ječmínek Ondřej","3-6",null,"2-6","2-6","4.","0"]
["A3","Suchánková Nikola -  Blaščík Matyáš","4-6","6-2",null,"6-3","2.","2"]
["A4","Bervid William - Wollner Filip","3-6","6-2","3-6",null,"3.","1"]
[]
["Skupina B -  kurt ",null,"Toman  Bruno -  Řehoř Benjamin","Roček  Vilém -  Plecitý Vilém","Hrubeš Martin - Mabouka Sofia","Šebísková Tereza -  Fiedlerová Enola","Zikmund Adam - Michna Lisa","Pořadí","Počet vítězství"]
["B1","Toman  Bruno -  Řehoř Benjamin",null,"6-3","6-2","3-6","3-6","3.","2"]
["B2","Roček  Vilém -  Plecitý Vilém","3-6",null,"7-5","3-6","3-6","4.","1"]
["B3","Hrubeš Martin - Mabouka Sofia","2-6","5-7",null,"6-7","3-6","5.","0"]
["B4","Šebísková Tereza -  Fiedlerová Enola","6-3","6-3","7-6",null,"3-6","2.","3"]
["B5","Zikmund Adam - Michna Lisa","6-3","6-3","6-3","6-3",null,"1.","4"]
[]
["Skupina C - kurt ",null,"Mrázek Richard - Zýka Andreas","Pospíšilová Anna - Stejskalová Julie","Svoboda Adéla - Burešová Karolína","Motal David - Mikeš David","Jiráková Sofie -  Adamcová Veronika","Pořadí","Počet vítězství"]
["C1","Mrázek Richard - Zýka Andreas",null,"6-4","6-3","6-7","6-7","3.","2"]
["C2","Pospíšilová Anna - Stejskalová Julie","4-6",null,"3-6","3-6","4-6","5.","0"]
["C3","Svoboda Adéla - Burešová Karolína","3-6","6-3",null,"2-6","3-6","4.","1"]
["C4","Motal David - Mikeš David","7-6","6-3","6-2",null,"7-5","1.","4"]
["C5","Jiráková Sofie -  Adamcová Veronika","7-6","6-4","6-3","5-7",null,"2.","3"]
[]
["Skupina D - kurt ",null,0,0,0,0,0,"Pořadí","Počet vítězství"]
["D1",0,null,0,0,0,0]
["D2",0,null,null,0,0,0]
["D3",0,null,null,null,0,0]
["D4",0,null,null,null,null,0]
["D5",0]
[]
["Skupina E - kurt",null,0,0,0,0,0,"Pořadí","Počet vítězství"]
["E1",0,null,0,0,0,0]
["E2",0,null,null,0,0,0]
["E3",0,null,null,null,0,0]
["E4",0,null,null,null,null,0]
["E5",0]
[]
["Skupina F - kurt",null,0,0,0,0,0,"Pořadí","Počet vítězství"]
["F1",0,null,0,0,0,0]
["F2",0,null,null,0,0,0]
["F3",0,null,null,null,0,0]
["F4",0,null,null,null,null,0]
["F5",0]
[]
["Skupina G - kurt ",null,0,0,0,0,0,"Pořadí","Počet vítězství"]
["G1",0,null,0,0,0,0]
["G2",0,null,null,0,0,0]
["G3",0,null,null,null,0,0]
["G4",0,null,null,null,null,0]
["G5",0]
[]
["Skupina H - kurt ",null,0,0,0,0,0,"Pořadí","Počet vítězství"]
["H1",0,null,0,0,0,0]
["H2",0,null,null,0,0,0]
["H3",0,null,null,null,0,0]
["H4",0,null,null,null,null,0]
["H5",0]
[]
["Skupina I - kurt ",null,0,0,0,0,0,"Pořadí","Počet vítězství"]
["I1",0,null,0,0,0,0]
["I2",0,null,null,0,0,0]
["I3",0,null,null,null,0,0]
["I4",0,null,null,null,null,0]
["I5",0]
[]
["Skupina J - kurt ",null,0,0,0,0,0,"Pořadí","Počet vítězství"]
["J1",0,null,0,0,0,0]
["J2",0,null,null,0,0,0]
["J3",0,null,null,null,0,0]
["J4",0,null,null,null,null,0]
["J5",0]

{"sheet":"pavouk","index":2,"n_rows":31,"n_cols":3,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"Kurylová Nicole"]
[null,"Weigert Matyáš"]
[]
[]
[null,null,"Mikeš David"]
[null,null,"Motal David"]
["Mikeš David",null,"6-4"]
["Motal David"]
[null,"Mikeš David"]
[null,"Motal David"]
["Šebístková Tereza","6-3"]
["Fiedlerová Enola"]
[null,null,"Mikeš David"]
[null,null,"Motal David"]
["Suchánková Nikola",null,"6-4"]
["Blaščík Matyáš"]
[null,"Suchánková Nikola"]
[null,"Blaščík Matyáš"]
["Jiráková Sofie","6-2"]
["Adamcová Veronika"]
[null,null,"Zikmund Adam"]
[null,null,"Michna L"]
[null,null,"6-4"]
[]
[null,"Zikmund Adam"]
[null,"Michna Lisa"]

{"sheet":"Pořadí chlapci","index":3,"n_rows":57,"n_cols":8,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
["POŘADÍ - SPARTA HEAD BABYTENIS TOUR LÉTO 2021 - CHLAPCI"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Pořadí","Příjmení","1. turnaj","2. turnaj","3. turnaj","4. turnaj","Masters","Celkem"]
["1.","Weigert Matyáš",300,250,100,null,null,650]
["2.-3.","Řehoř Benjamín",200,200,10,null,null,410]
[null,"Mrazek Richard",200,200,10,null,null,410]
["4.-5.","Šuda Jakub",250,0,0,null,null,250]
[null,"Mikeš David",100,0,150,null,null,250]
["6.","Blaščík Matyáš",0,100,100,null,null,200]
["7.","Zikmund Adam",20,20,125,null,null,165]
["8.","Motal David",10,0,150,null,null,160]
["9.","Krkoška Šimon",100,0,0,null,null,100]
["10.I","Toman Bruno",20,10,10,null,null,40]
["11.","Bervid William",20,0,10,null,null,30]
["12.- 16.","Nedoma Nataniel",10,0,0,null,null,10]
[null,"Dvořák Jan",10,0,0,null,null,10]
[null,"Sklenička Vojtěch",0,10,0,null,null,10]
[null,"Wollner Filip",0,0,10,null,null,10]
[null,"Zýka Andreas",0,0,10,null,null,10]
["17.- 23.","Večeř Dominik",5,0,0,null,null,5]
[null,"Obyt Tobiáš",5,0,0,null,null,5]
[null,"Melša Petr",0,5,0,null,null,5]
[null,"Rabas Jáchym",0,5,0,null,null,5]
[null,"Roček Vilém",0,0,5,null,null,5]
[null,"Plecitý Vilém",0,0,5,null,null,5]
[null,"Ječmínek Ondřej",0,0,5,null,null,5]
["24.","Hrubeš Martin",0,0,"2,5",null,null,"2,5"]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]

{"sheet":"Pořadí dívky","index":4,"n_rows":57,"n_cols":8,"rows_kept":57,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["POŘADÍ - SPARTA HEAD BABYTENIS TOUR LÉto 2021 - DÍVKY"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Pořadí","Příjmení","1. turnaj","2. turnaj","3. turnaj","4. turnaj","Masters","Celkem"]
["1.","Marešová Beata",300,300,0,null,null,{"$f":"C25+D25","v":600}]
["2.","Michna Lisa",250,0,125,null,null,{"$f":"SUM(C26:G26)","v":375}]
["3.","Jiráková Sofie",200,0,50,null,null,{"$f":"SUM(C27:G27)","v":250}]
["4.","Nikodymová Kristýna",200,20,0,null,null,{"$f":"C28+D28","v":220}]
["5.","Svoboda Adéla",100,100,5,null,null,{"$f":"SUM(C29:G29)","v":205}]
["6.","Kurylova Nicole",100,0,100,null,null,{"$f":"SUM(C30:G30)","v":200}]
["7.","Šebístková Tereza",100,0,50,null,null,{"$f":"SUM(C31:G31)","v":150}]
["8.","Burešová Karolína",100,20,5,null,null,{"$f":"SUM(C32:G32)","v":125}]
["9.","Suchánková Nikola",0,0,100,null,null,100]
["10.- 11.","Fiedlerová  Enola",0,0,50,null,null,50]
[null,"Adamcová veronika",0,0,50,null,null,50]
["12.","Dušková Diana",20,10,0,null,null,{"$f":"C36+D36","v":30}]
["13.- 15.","Kubíková Kateřina",20,0,0,null,null,20]
[null,"Janouchová Nikola",20,0,0,null,null,20]
[null,"Cajthamlová Anežka",20,0,0,null,null,20]
["16.- 19.","Klokočková Sára",10,0,0,null,null,10]
[null,"Plzáková Dominika",10,0,0,null,null,10]
[null,"Haskell Mia",10,0,0,null,null,10]
[null,"Řízková Michaela",10,0,0,null,null,10]
["20.","Hugová  Kateřina",0,0,5,null,null,{"$f":"SUM(C44:G44)","v":5}]
["21.- 23.","Pospíšilová  Anna",0,0,2.5,null,null,2.5]
[null,"Stejskalová Julie",0,0,2.5,null,null,2.5]
[null,"Mabouka Sofia",0,0,2.5,null,null,2.5]
[null,null,null,null,null,null,null,{"$f":"C48+D48","v":0}]
[null,null,null,null,null,null,null,{"$f":"C49+D49","v":0}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]